Structured Query Language -- An Introduction, provides a comprehensive tutorial and reference for database programmers
ofall skill levels. Using the open source database PostgreSQL as a reference, the reader is taken from the basics of
creatinga database, setting permissions, and designing and implementing tables. The reader is introduced to searching
forrecords in the database using queries, adding new data, updating existing data, and deleting data.
Advanced topics are also included, such as: the creation and usage of indices for faster queries; the use of
transactionsto ensure database integrity; design and implementation of primary keys, foreign keys, and alternate keys;
joiningmultiple tables in a single query; and database security.
Additional information available at:
http://www.lulu.com/165318
